--------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE\code\data_cleaning\pred_wage_inst
> rument\logs\topcode_report_post_samplerestrictions.log
  log type:  text
 opened on:   9 Jul 2025, 13:42:27

. 
. gen inc_tc = incwage >= 240000 if incwage != .

. gen uhrs_tc = uhrswork == 99 if uhrswork != .

. 
. * full distribution of inc/ushrswork *
. summ incwage uhrswork [aw=perwt],d

                   Wage and salary income
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1200            100
 5%         3200            100
10%         6000            100       Obs           5,839,605
25%        13900            100       Sum of Wgt.   119994628

50%        25900                      Mean           33333.71
                        Largest       Std. Dev.      35482.44
75%        42000         385000
90%        64000         385000       Variance       1.26e+09
95%        83000         385000       Skewness       4.641696
99%       151000         385000       Kurtosis       35.47031

                 Usual hours worked per week
-------------------------------------------------------------
      Percentiles      Smallest
 1%           12             10
 5%           20             10
10%           25             10       Obs           5,839,605
25%           40             10       Sum of Wgt.   119994628

50%           40                      Mean           40.65839
                        Largest       Std. Dev.      11.13156
75%           45             98
90%           52             98       Variance       123.9117
95%           60             98       Skewness          .2038
99%           72             98       Kurtosis       5.234536

. 
. * top-coded distribution of inc/ushrswork *
. summ incwage [aw=perwt] if inc_tc ==1,d

                   Wage and salary income
-------------------------------------------------------------
      Percentiles      Smallest
 1%       295000         240000
 5%       305000         240000
10%       308000         240000       Obs              43,140
25%       314000         240000       Sum of Wgt.     923,393

50%       321000                      Mean             321370
                        Largest       Std. Dev.      13129.06
75%       325000         385000
90%       347000         385000       Variance       1.72e+08
95%       347000         385000       Skewness       .4432482
99%       354000         385000       Kurtosis       5.678105

. summ uhrswork [aw=perwt] if uhrs_tc ==1,d

                 Usual hours worked per week
-------------------------------------------------------------
no observations

. 
. * FRACTION INC/HOURS TOPCODED BY EDL *
. bys edl: sum inc_tc uhrs_tc [aw=perwt]

--------------------------------------------------------------------------------------------------------------------------------------
-> edl = <12

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
      inc_tc | 473,856     9457525    .0006939   .0263337          0          1
     uhrs_tc | 473,856     9457525           0          0          0          0

--------------------------------------------------------------------------------------------------------------------------------------
-> edl = 12

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
      inc_tc | 2354142    46826848    .0013618   .0368769          0          1
     uhrs_tc | 2354142    46826848           0          0          0          0

--------------------------------------------------------------------------------------------------------------------------------------
-> edl = 13-15

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
      inc_tc | 1459535    30386231    .0028069   .0529055          0          1
     uhrs_tc | 1459535    30386231           0          0          0          0

--------------------------------------------------------------------------------------------------------------------------------------
-> edl = 16

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
      inc_tc | 1014399    21858031    .0144696   .1194161          0          1
     uhrs_tc | 1014399    21858031           0          0          0          0

--------------------------------------------------------------------------------------------------------------------------------------
-> edl = 17+

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
      inc_tc | 537,673    11465993    .0393771   .1944905          0          1
     uhrs_tc | 537,673    11465993           0          0          0          0


. 
. log close 
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE\code\data_cleaning\pred_wage_inst
> rument\logs\topcode_report_post_samplerestrictions.log
  log type:  text
 closed on:   9 Jul 2025, 13:42:35
--------------------------------------------------------------------------------------------------------------------------------------
